
load data
INTO TABLE stockinfo
APPEND
FIELDS TERMINATED BY ',' 
(stockdate date 'yyyy-mm-dd',
 open     ,
 high     ,
 low      ,
 close     ,
 volume    ,
 adjclose  ,
 stockcode ) 

	 